

![]() | Start a set with this search |
![]() | Include this search in one of my sets |
![]() | Exclude this search from one of my sets |
![]() | Permalink to these results Paste this link in email or IM: |
| Atom feed for tracking future search results Paste this URL into your reader: |
105 messages in org.oasis-open.lists.office-formulaRe: [office-formula] Semantics| From | Sent On | Attachments |
|---|---|---|
| 46 earlier messages | ||
| Eike Rathke | Feb 28, 2006 11:52 am | |
| Bastian, Waldo | Feb 28, 2006 12:24 pm | |
| Eike Rathke | Feb 28, 2006 12:26 pm | |
| Eike Rathke | Feb 28, 2006 12:30 pm | |
| Daniel Carrera | Feb 28, 2006 1:01 pm | |
| David A. Wheeler | Feb 28, 2006 1:11 pm | |
| Bastian, Waldo | Feb 28, 2006 2:57 pm | |
| Tom Metcalf | Feb 28, 2006 3:05 pm | |
| robe...@us.ibm.com | Feb 28, 2006 4:28 pm | |
| Tomas Mecir | Mar 1, 2006 12:26 am | |
| Tomas Mecir | Mar 1, 2006 12:35 am | |
| Tomas Mecir | Mar 1, 2006 12:43 am | |
| Daniel Carrera | Mar 1, 2006 2:08 am | |
| Eike Rathke | Mar 1, 2006 3:47 am | |
| Tomas Mecir | Mar 1, 2006 3:59 am | |
| Eike Rathke | Mar 1, 2006 5:05 am | |
| Tomas Mecir | Mar 1, 2006 5:30 am | |
| robe...@us.ibm.com | Mar 1, 2006 5:32 am | |
| Daniel Carrera | Mar 1, 2006 6:14 am | |
| David A. Wheeler | Mar 1, 2006 7:06 am | |
| robe...@us.ibm.com | Mar 1, 2006 7:15 am | |
| Eike Rathke | Mar 1, 2006 7:50 am | |
| Eike Rathke | Mar 1, 2006 8:21 am | |
| Eike Rathke | Mar 1, 2006 8:24 am | |
| Eike Rathke | Mar 1, 2006 8:29 am | |
| Tomas Mecir | Mar 1, 2006 8:32 am | |
| Tomas Mecir | Mar 1, 2006 8:40 am | |
| Richard Kernick | Mar 1, 2006 10:43 am | |
| Richard Kernick | Mar 1, 2006 10:43 am | |
| robe...@us.ibm.com | Mar 1, 2006 12:35 pm | |
| Richard Kernick | Mar 1, 2006 2:08 pm | |
| Daniel Carrera | Mar 1, 2006 2:27 pm | |
| David A. Wheeler | Mar 1, 2006 2:38 pm | |
| robe...@us.ibm.com | Mar 1, 2006 3:44 pm | |
| David A. Wheeler | Mar 1, 2006 4:09 pm | |
| Eike Rathke | Mar 2, 2006 12:23 pm | |
| Tomas Mecir | Mar 3, 2006 12:32 am | |
| Richard Kernick | Mar 4, 2006 12:58 pm | |
| Tomas Mecir | Mar 5, 2006 2:52 am | |
| David A. Wheeler | Mar 5, 2006 11:03 am | |
| Daniel Carrera | Mar 6, 2006 1:19 am | |
| Tomas Mecir | Mar 6, 2006 1:40 am | |
| Eike Rathke | Mar 6, 2006 8:14 am | |
| Tomas Mecir | Mar 6, 2006 8:19 am | |
| Tomas Mecir | Mar 6, 2006 8:21 am | |
| Eike Rathke | Mar 6, 2006 8:26 am | |
| Eike Rathke | Mar 6, 2006 8:42 am | |
| robe...@us.ibm.com | Mar 6, 2006 10:03 am | |
| Daniel Carrera | Mar 6, 2006 12:20 pm | |
| robe...@us.ibm.com | Mar 6, 2006 12:49 pm | |
| Richard Kernick | Mar 6, 2006 4:37 pm | |
| Daniel Carrera | Mar 7, 2006 1:15 am | |
| Tomas Mecir | Mar 7, 2006 1:21 am | |
| Richard Kernick | Mar 7, 2006 3:00 pm | |
| Eike Rathke | Mar 8, 2006 9:30 am | |
| Eike Rathke | Mar 8, 2006 9:48 am | |
| Eike Rathke | Mar 8, 2006 9:53 am | |
| Eike Rathke | Mar 8, 2006 10:02 am | |
| Eike Rathke | Mar 8, 2006 10:16 am | |

![]() | Permalink for this message Paste this link in email or IM: |
![]() | Permalink for this thread Paste this link in email or IM: |
| Atom feed for this thread Paste this URL into your reader: |
| Subject: | Re: [office-formula] Semantics | Actions... |
|---|---|---|
| From: | robe...@us.ibm.com (robe...@us.ibm.com) | |
| Date: | Mar 6, 2006 12:49:58 pm | |
| List: | org.oasis-open.lists.office-formula | |
OK. So someone who has a process that takes a table of conversion factors from the web and pastes these into a spreadsheet and then uses automatic string->number conversions to do a calculation would create a spreadsheet which would work in one locale, but would break in another.
This makes me think that we shouldn't spend to much time on this area. Specify how it works today in OO (or Excel or whatever) and immediately deprecate this feature in the grammar. I think we want to be promoting a file format which encourages and supports the creation of formulas which are invariant under locale changes. Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. We should probably make a whole list of stuff which we'll need to define for legacy application compatibility, but which we'll want to immediately deprecate.
-Rob
Daniel Carrera <dani...@zmsl.com> wrote on 03/06/2006 03:23:18 PM:
robe...@us.ibm.com wrote:
Interesting debate.
How hard is it to come up with a real-world example of a formula which would give a different result based on the locale of the user who opens it? Not just a different presentation, but an actual different meaning. If this can ever happen, it would be a bad thing, IMHO.
I must not be understanding this question because it seems too easy. For example, the exchange rate from Euros to Canadian dollars is 1,369 if you are in Germany but that will give you the wrong result if you use that string in Canada.
Daniel.
-- /\/`) http://opendocumentfellowship.org /\/_/ /\/_/ I'm not saying there should be a capital punishment for \/_/ stupidity, but why don't we just take the safety labels / off of everything and let the problem solve itself?







